package com.bw.gmallbi.mapper;

import com.bw.gmallbi.bean.ProvinceStats;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

// 地区统计Mapper
public interface ProvinceStatsMapper {

    // 全国的销售情况
    @Select("select province_id,province_name,sum(order_amount) order_amount from province_stats_2105b " +
            "where toYYYYMMDD(stt)=#{date} group by province_id,province_name")
    List<ProvinceStats> selectProvinceStats(@Param("date") Integer date);

}
